﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="JOBS.aspx.vb" Inherits="PRUEVANET3.Formulario_web13" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" 
    DataKeyNames="job_id" DataSourceID="SqlDataSource1" 
    EmptyDataText="No hay registros de datos para mostrar.">
    <Columns>
        <asp:BoundField DataField="job_id" HeaderText="job_id" ReadOnly="True" 
            SortExpression="job_id" InsertVisible="False" />
        <asp:BoundField DataField="job_desc" HeaderText="job_desc" 
            SortExpression="job_desc" />
        <asp:BoundField DataField="min_lvl" HeaderText="min_lvl" 
            SortExpression="min_lvl" />
        <asp:BoundField DataField="max_lvl" HeaderText="max_lvl" 
            SortExpression="max_lvl" />
    </Columns>
    <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
    <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
    <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
    <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
    <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
    <SortedAscendingCellStyle BackColor="#FFF1D4" />
    <SortedAscendingHeaderStyle BackColor="#B95C30" />
    <SortedDescendingCellStyle BackColor="#F1E5CE" />
    <SortedDescendingHeaderStyle BackColor="#93451F" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:pubsConnectionString3 %>" 
    DeleteCommand="DELETE FROM [jobs] WHERE [job_id] = @original_job_id AND [job_desc] = @original_job_desc AND [min_lvl] = @original_min_lvl AND [max_lvl] = @original_max_lvl" 
    InsertCommand="INSERT INTO [jobs] ([job_desc], [min_lvl], [max_lvl]) VALUES (@job_desc, @min_lvl, @max_lvl)" 
    ProviderName="<%$ ConnectionStrings:PUBSConnectionString.ProviderName %>" 
    SelectCommand="SELECT [job_id], [job_desc], [min_lvl], [max_lvl] FROM [jobs]" 
    
    UpdateCommand="UPDATE [jobs] SET [job_desc] = @job_desc, [min_lvl] = @min_lvl, [max_lvl] = @max_lvl WHERE [job_id] = @original_job_id AND [job_desc] = @original_job_desc AND [min_lvl] = @original_min_lvl AND [max_lvl] = @original_max_lvl" 
    ConflictDetection="CompareAllValues" 
    OldValuesParameterFormatString="original_{0}">
    <DeleteParameters>
        <asp:Parameter Name="original_job_id" Type="Int16" />
        <asp:Parameter Name="original_job_desc" Type="String" />
        <asp:Parameter Name="original_min_lvl" Type="Byte" />
        <asp:Parameter Name="original_max_lvl" Type="Byte" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="job_desc" Type="String" />
        <asp:Parameter Name="min_lvl" Type="Byte" />
        <asp:Parameter Name="max_lvl" Type="Byte" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="job_desc" Type="String" />
        <asp:Parameter Name="min_lvl" Type="Byte" />
        <asp:Parameter Name="max_lvl" Type="Byte" />
        <asp:Parameter Name="original_job_id" Type="Int16" />
        <asp:Parameter Name="original_job_desc" Type="String" />
        <asp:Parameter Name="original_min_lvl" Type="Byte" />
        <asp:Parameter Name="original_max_lvl" Type="Byte" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>
